SELECT current_plan_package,business_name,
business_id,
big_description,
small_description,
address1,
address2,
building_name,
area, city,
nearest_busstop,
state,
country,
zipcode, seo_url FROM bd_business_description WHERE mirror='0' AND status='1' AND city='Lekki Phase 1' AND state='Lagos ' AND country='Nigeria' AND business_id IN( SELECT business_id FROM bd_business_category WHERE category_id IN (SELECT CategoryID FROM bd_category WHERE Name='Real Estate Brokers') ) ORDER BY current_plan_package DESC
We are a modern Real Estate company which deals in sales and rentals. We aim to improve customer experience, quality of service and productivity in the real estate business in Nigeria. We are trained agents and we offer high-end and affordable properties with best deals you cannot find easily elsewhere. Innovative and forward-looking Real Estate company in Lagos Nigeria offering properties for sale or rent. We have a wide range of products to meet a wide range of clientele tastes and requirements.